Overview

Dataset Statistics

Number of Variables 47
Number of Rows 361
Missing Cells 3139
Missing Cells (%) 18.5%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 165.8 KB
Average Row Size in Memory 470.2 B
Variable Types
  • DateTime: 1
  • Numerical: 39
  • Categorical: 7

Dataset Insights

ENGINE01_RUNTIME and ENGINE01_HEAT_PRODUCTION have similar distributions Similar Distribution
ENGINE01_RUNTIME and HOB_A_DAY_RUNTIME have similar distributions Similar Distribution
ENGINE01_RUNTIME and HOB_B_DAY_RUNTIME have similar distributions Similar Distribution
ENGINE02_RUNTIME and ENGINE03_RUNTIME have similar distributions Similar Distribution
ENGINE02_RUNTIME and HEATPUMP_DAY_RUNTIME have similar distributions Similar Distribution
ENGINE03_RUNTIME and HEATPUMP_HEAT_PRODUCTION have similar distributions Similar Distribution
ENGINE01_HEAT_PRODUCTION and HOB_A_DAY_RUNTIME have similar distributions Similar Distribution
ENGINE01_HEAT_PRODUCTION and HOB_B_DAY_RUNTIME have similar distributions Similar Distribution
HOB_A_DAY_RUNTIME and HOB_B_DAY_RUNTIME have similar distributions Similar Distribution
ENGINE03_POWER_PRODUCTION and ENGINE01_FUEL_USAGE have similar distributions Similar Distribution
ENGINE02_FUEL_USAGE and ENGINE03_FUEL_USAGE have similar distributions Similar Distribution
ENGINE01_POWER_EFFICIENCE and ENGINE01_HEAT_EFFICIENCE have similar distributions Similar Distribution
ENGINE01_POWER_EFFICIENCE and ENGINE01_TOTAL_EFFICIENCE have similar distributions Similar Distribution
ENGINE01_POWER_EFFICIENCE and ENGINE03_POWER_EFFICIENCE have similar distributions Similar Distribution
ENGINE01_HEAT_EFFICIENCE and ENGINE01_TOTAL_EFFICIENCE have similar distributions Similar Distribution
ENGINE01_HEAT_EFFICIENCE and ENGINE03_POWER_EFFICIENCE have similar distributions Similar Distribution
ENGINE01_HEAT_EFFICIENCE and ENGINE03_HEAT_EFFICIENCE have similar distributions Similar Distribution
ENGINE01_HEAT_EFFICIENCE and ENGINE03_TOTAL_EFFICIENCE have similar distributions Similar Distribution
ENGINE02_HEAT_EFFICIENCE and ENGINE03_HEAT_EFFICIENCE have similar distributions Similar Distribution
ENGINE02_TOTAL_EFFICIENCE and ENGINE03_TOTAL_EFFICIENCE have similar distributions Similar Distribution
FUELCELL_RECEIVED_HEAT_AMOUNT has 126 (34.9%) missing values Missing
HEATPUMP_DAY_RUNTIME has 7 (1.94%) missing values Missing
HEATPUMP_ACCUM_RUNTIME has 180 (49.86%) missing values Missing
HOB_A_DAY_RUNTIME has 9 (2.49%) missing values Missing
HOB_B_DAY_RUNTIME has 10 (2.77%) missing values Missing
HOB_A_ACCUM_RUNTIME has 180 (49.86%) missing values Missing
HOB_B_ACCUM_RUNTIME has 180 (49.86%) missing values Missing
ENGINE01_POWER_PRODUCTION has 52 (14.4%) missing values Missing
ENGINE02_POWER_PRODUCTION has 52 (14.4%) missing values Missing
ENGINE03_POWER_PRODUCTION has 52 (14.4%) missing values Missing
ENGINE_TOTAL_POWER_PRODUCTION has 52 (14.4%) missing values Missing
ENGINE01_FUEL_USAGE has 52 (14.4%) missing values Missing
ENGINE02_FUEL_USAGE has 52 (14.4%) missing values Missing
ENGINE03_FUEL_USAGE has 52 (14.4%) missing values Missing
ENGINE_TOTAL_FUEL_USAGE has 52 (14.4%) missing values Missing
ENGINE01_POWER_EFFICIENCE has 214 (59.28%) missing values Missing
ENGINE01_HEAT_EFFICIENCE has 214 (59.28%) missing values Missing
ENGINE01_TOTAL_EFFICIENCE has 214 (59.28%) missing values Missing
ENGINE02_POWER_EFFICIENCE has 158 (43.77%) missing values Missing
ENGINE02_HEAT_EFFICIENCE has 158 (43.77%) missing values Missing
ENGINE02_TOTAL_EFFICIENCE has 158 (43.77%) missing values Missing
ENGINE03_POWER_EFFICIENCE has 186 (51.52%) missing values Missing
ENGINE03_HEAT_EFFICIENCE has 186 (51.52%) missing values Missing
ENGINE03_TOTAL_EFFICIENCE has 186 (51.52%) missing values Missing
REG_DT has 177 (49.03%) missing values Missing
REG_USER has 180 (49.86%) missing values Missing
ENGINE01_POWER_GEN_METER is skewed Skewed
ENGINE02_POWER_GEN_METER is skewed Skewed
ENGINE03_POWER_GEN_METER is skewed Skewed
ENGINE01_RUNTIME is skewed Skewed
ENGINE02_RUNTIME is skewed Skewed
ENGINE03_RUNTIME is skewed Skewed
ENGINE01_ACCUM_RUNTIME is skewed Skewed
ENGINE02_ACCUM_RUNTIME is skewed Skewed
ENGINE03_ACCUM_RUNTIME is skewed Skewed
ENGINE01_HEAT_PRODUCTION is skewed Skewed
ENGINE02_HEAT_PRODUCTION is skewed Skewed
ENGINE03_HEAT_PRODUCTION is skewed Skewed
HEATPUMP_HEAT_PRODUCTION is skewed Skewed
ENGINE01_FUEL_USAGE_METER is skewed Skewed
ENGINE02_FUEL_USAGE_METER is skewed Skewed
ENGINE03_FUEL_USAGE_METER is skewed Skewed
HOB_FUEL_USAGE is skewed Skewed
HEATPUMP_DAY_RUNTIME is skewed Skewed
HOB_A_DAY_RUNTIME is skewed Skewed
HOB_B_DAY_RUNTIME is skewed Skewed
ENGINE01_POWER_PRODUCTION is skewed Skewed
ENGINE02_POWER_PRODUCTION is skewed Skewed
ENGINE03_POWER_PRODUCTION is skewed Skewed
ENGINE_TOTAL_POWER_PRODUCTION is skewed Skewed
ENGINE01_FUEL_USAGE is skewed Skewed
ENGINE02_FUEL_USAGE is skewed Skewed
ENGINE03_FUEL_USAGE is skewed Skewed
ENGINE_TOTAL_FUEL_USAGE is skewed Skewed
ENGINE01_POWER_EFFICIENCE is skewed Skewed
ENGINE01_HEAT_EFFICIENCE is skewed Skewed
ENGINE01_TOTAL_EFFICIENCE is skewed Skewed
ENGINE02_POWER_EFFICIENCE is skewed Skewed
ENGINE02_HEAT_EFFICIENCE is skewed Skewed
ENGINE02_TOTAL_EFFICIENCE is skewed Skewed
ENGINE03_POWER_EFFICIENCE is skewed Skewed
ENGINE03_HEAT_EFFICIENCE is skewed Skewed
ENGINE03_TOTAL_EFFICIENCE is skewed Skewed
REG_DT has a high cardinality: 181 distinct values High Cardinality
HEATPUMP_ACCUM_RUNTIME has constant value "0.0" Constant
HOB_A_ACCUM_RUNTIME has constant value "0.0" Constant
HOB_B_ACCUM_RUNTIME has constant value "0.0" Constant
HEATPUMP_ACCUM_RUNTIME has constant length 3 Constant Length
HOB_A_ACCUM_RUNTIME has constant length 3 Constant Length
HOB_B_ACCUM_RUNTIME has constant length 3 Constant Length
REG_DT has constant length 23 Constant Length
ENGINE01_RUNTIME has 325 (90.03%) zeros Zeros
ENGINE02_RUNTIME has 247 (68.42%) zeros Zeros
ENGINE03_RUNTIME has 268 (74.24%) zeros Zeros
ENGINE01_HEAT_PRODUCTION has 331 (91.69%) zeros Zeros
ENGINE02_HEAT_PRODUCTION has 248 (68.7%) zeros Zeros
ENGINE03_HEAT_PRODUCTION has 267 (73.96%) zeros Zeros
HEATPUMP_HEAT_PRODUCTION has 236 (65.37%) zeros Zeros
HEATPUMP_DAY_RUNTIME has 226 (62.6%) zeros Zeros
HOB_A_DAY_RUNTIME has 328 (90.86%) zeros Zeros
HOB_B_DAY_RUNTIME has 331 (91.69%) zeros Zeros
ENGINE01_POWER_PRODUCTION has 275 (76.18%) zeros Zeros
ENGINE02_POWER_PRODUCTION has 200 (55.4%) zeros Zeros
ENGINE03_POWER_PRODUCTION has 220 (60.94%) zeros Zeros
ENGINE_TOTAL_POWER_PRODUCTION has 137 (37.95%) zeros Zeros
ENGINE01_FUEL_USAGE has 242 (67.04%) zeros Zeros
ENGINE02_FUEL_USAGE has 171 (47.37%) zeros Zeros
ENGINE03_FUEL_USAGE has 189 (52.35%) zeros Zeros
ENGINE_TOTAL_FUEL_USAGE has 110 (30.47%) zeros Zeros
ENGINE01_POWER_EFFICIENCE has 113 (31.3%) zeros Zeros
ENGINE01_HEAT_EFFICIENCE has 118 (32.69%) zeros Zeros
ENGINE01_TOTAL_EFFICIENCE has 113 (31.3%) zeros Zeros
ENGINE02_POWER_EFFICIENCE has 117 (32.41%) zeros Zeros
ENGINE02_HEAT_EFFICIENCE has 120 (33.24%) zeros Zeros
ENGINE02_TOTAL_EFFICIENCE has 117 (32.41%) zeros Zeros
ENGINE03_POWER_EFFICIENCE has 123 (34.07%) zeros Zeros
ENGINE03_HEAT_EFFICIENCE has 126 (34.9%) zeros Zeros
ENGINE03_TOTAL_EFFICIENCE has 123 (34.07%) zeros Zeros
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12

Variables


DT

datetime

Distinct Count 360.9924
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Memory Size 2.9 KB
Minimum 2020-01-01 00:00:00
Maximum 2021-01-05 00:00:00

ENGINE01_POWER_GEN_METER

numerical

Approximate Distinct Count 35
Approximate Unique (%) 9.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 198261.4125
Minimum 196926.71
Maximum 199452.31
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_POWER_GEN_METER is skewed left (γ1 = -0.0867)

Quantile Statistics

Minimum 196926.71
5-th Percentile 197145.35
Q1 198182.39
Median 198310.1
Q3 198356.76
95-th Percentile 199452.31
Maximum 199452.31
Range 2525.6
IQR 174.37

Descriptive Statistics

Mean 198261.4125
Standard Deviation 524.67
Variance 275278.5963
Sum 7.1572e+07
Skewness -0.08669
Kurtosis 1.4422
Coefficient of Variation 0.002646
  • ENGINE01_POWER_GEN_METER is not normally distributed (p-value 3.3829726277451086e-18)
  • ENGINE01_POWER_GEN_METER has 95 outliers

ENGINE02_POWER_GEN_METER

numerical

Approximate Distinct Count 114
Approximate Unique (%) 31.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 185547.4988
Minimum 177224.95
Maximum 191192.79
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_POWER_GEN_METER is skewed left (γ1 = -1.3077)

Quantile Statistics

Minimum 177224.95
5-th Percentile 180540.92
Q1 185430.15
Median 186152.5
Q3 186700.43
95-th Percentile 188578.96
Maximum 191192.79
Range 13967.84
IQR 1270.28

Descriptive Statistics

Mean 185547.4988
Standard Deviation 2360.1328
Variance 5.5702e+06
Sum 6.6983e+07
Skewness -1.3077
Kurtosis 2.2514
Coefficient of Variation 0.01272
  • ENGINE02_POWER_GEN_METER is not normally distributed (p-value 1.86424172474857e-19)
  • ENGINE02_POWER_GEN_METER has 79 outliers

ENGINE03_POWER_GEN_METER

numerical

Approximate Distinct Count 95
Approximate Unique (%) 26.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 103832.2365
Minimum 99098.17
Maximum 109166.73
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_POWER_GEN_METER is skewed left (γ1 = -0.199)

Quantile Statistics

Minimum 99098.17
5-th Percentile 99606.8
Q1 103345.41
Median 103770.25
Q3 104755.49
95-th Percentile 107311.51
Maximum 109166.73
Range 10068.56
IQR 1410.08

Descriptive Statistics

Mean 103832.2365
Standard Deviation 1902.5982
Variance 3.6199e+06
Sum 3.7483e+07
Skewness -0.199
Kurtosis 1.2899
Coefficient of Variation 0.01832
  • ENGINE03_POWER_GEN_METER is not normally distributed (p-value 2.011014088757287e-15)
  • ENGINE03_POWER_GEN_METER has 57 outliers

ENGINE01_RUNTIME

numerical

Approximate Distinct Count 30
Approximate Unique (%) 8.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 0.8888
Minimum 0
Maximum 24
Zeros 325
Zeros (%) 90.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_RUNTIME is skewed right (γ1 = 4.873)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 5.87
Maximum 24
Range 24
IQR 0

Descriptive Statistics

Mean 0.8888
Standard Deviation 3.7211
Variance 13.8464
Sum 320.84
Skewness 4.873
Kurtosis 24.1203
Coefficient of Variation 4.1868
  • ENGINE01_RUNTIME is not normally distributed (p-value 4.358897514027656e-25)
  • ENGINE01_RUNTIME has 36 outliers

ENGINE02_RUNTIME

numerical

Approximate Distinct Count 52
Approximate Unique (%) 14.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 4.7645
Minimum 0
Maximum 64.09
Zeros 247
Zeros (%) 68.4%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_RUNTIME is skewed right (γ1 = 2.0796)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 6.5
95-th Percentile 24
Maximum 64.09
Range 64.09
IQR 6.5

Descriptive Statistics

Mean 4.7645
Standard Deviation 8.6157
Variance 74.2307
Sum 1719.99
Skewness 2.0796
Kurtosis 5.9916
Coefficient of Variation 1.8083
  • ENGINE02_RUNTIME is not normally distributed (p-value 1.2842948805532526e-24)
  • ENGINE02_RUNTIME has 48 outliers

ENGINE03_RUNTIME

numerical

Approximate Distinct Count 56
Approximate Unique (%) 15.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 3.4598
Minimum 0
Maximum 115.48
Zeros 268
Zeros (%) 74.2%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_RUNTIME is skewed right (γ1 = 6.8054)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1.5
95-th Percentile 17
Maximum 115.48
Range 115.48
IQR 1.5

Descriptive Statistics

Mean 3.4598
Standard Deviation 8.6105
Variance 74.1407
Sum 1248.996
Skewness 6.8054
Kurtosis 78.2512
Coefficient of Variation 2.4887
  • ENGINE03_RUNTIME is not normally distributed (p-value 7.492209199318905e-25)
  • ENGINE03_RUNTIME has 84 outliers

ENGINE01_ACCUM_RUNTIME

numerical

Approximate Distinct Count 34
Approximate Unique (%) 9.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 23857.0517
Minimum 23695
Maximum 24002
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_ACCUM_RUNTIME is skewed left (γ1 = -0.0819)

Quantile Statistics

Minimum 23695
5-th Percentile 23720.2
Q1 23847
Median 23863
Q3 23869
95-th Percentile 24002
Maximum 24002
Range 307
IQR 22

Descriptive Statistics

Mean 23857.0517
Standard Deviation 63.7655
Variance 4066.0326
Sum 8.6124e+06
Skewness -0.08186
Kurtosis 1.4288
Coefficient of Variation 0.002673
  • ENGINE01_ACCUM_RUNTIME is not normally distributed (p-value 2.8852960495113987e-18)
  • ENGINE01_ACCUM_RUNTIME has 89 outliers

ENGINE02_ACCUM_RUNTIME

numerical

Approximate Distinct Count 113
Approximate Unique (%) 31.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 22417.0526
Minimum 21413
Maximum 23096
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_ACCUM_RUNTIME is skewed left (γ1 = -1.2946)

Quantile Statistics

Minimum 21413
5-th Percentile 21809
Q1 22400
Median 22488
Q3 22562
95-th Percentile 22786
Maximum 23096
Range 1683
IQR 162

Descriptive Statistics

Mean 22417.0526
Standard Deviation 286.7879
Variance 82247.2944
Sum 8.0926e+06
Skewness -1.2946
Kurtosis 2.1642
Coefficient of Variation 0.01279
  • ENGINE02_ACCUM_RUNTIME is not normally distributed (p-value 3.475260968063684e-19)
  • ENGINE02_ACCUM_RUNTIME has 77 outliers

ENGINE03_ACCUM_RUNTIME

numerical

Approximate Distinct Count 95
Approximate Unique (%) 26.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 12376.2148
Minimum 11809
Maximum 13019
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_ACCUM_RUNTIME is skewed left (γ1 = -0.1674)

Quantile Statistics

Minimum 11809
5-th Percentile 11869
Q1 12313
Median 12364
Q3 12494
95-th Percentile 12799
Maximum 13019
Range 1210
IQR 181

Descriptive Statistics

Mean 12376.2148
Standard Deviation 230.6735
Variance 53210.2834
Sum 4.4678e+06
Skewness -0.1674
Kurtosis 1.1798
Coefficient of Variation 0.01864
  • ENGINE03_ACCUM_RUNTIME is not normally distributed (p-value 2.219331141785611e-19)
  • ENGINE03_ACCUM_RUNTIME has 56 outliers

ENGINE01_HEAT_PRODUCTION

numerical

Approximate Distinct Count 30
Approximate Unique (%) 8.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 5.4316
Minimum 0
Maximum 162.28
Zeros 331
Zeros (%) 91.7%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_HEAT_PRODUCTION is skewed right (γ1 = 5.0685)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 34.35
Maximum 162.28
Range 162.28
IQR 0

Descriptive Statistics

Mean 5.4316
Standard Deviation 24.062
Variance 578.982
Sum 1960.815
Skewness 5.0685
Kurtosis 26.0439
Coefficient of Variation 4.43
  • ENGINE01_HEAT_PRODUCTION is not normally distributed (p-value 4.2829459912661695e-25)
  • ENGINE01_HEAT_PRODUCTION has 30 outliers

ENGINE02_HEAT_PRODUCTION

numerical

Approximate Distinct Count 114
Approximate Unique (%) 31.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 29.4788
Minimum 0
Maximum 196.89
Zeros 248
Zeros (%) 68.7%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_HEAT_PRODUCTION is skewed right (γ1 = 1.5571)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 38.03
95-th Percentile 155
Maximum 196.89
Range 196.89
IQR 38.03

Descriptive Statistics

Mean 29.4788
Standard Deviation 52.0219
Variance 2706.2815
Sum 10641.846
Skewness 1.5571
Kurtosis 0.9411
Coefficient of Variation 1.7647
  • ENGINE02_HEAT_PRODUCTION is not normally distributed (p-value 5.737680605256057e-25)
  • ENGINE02_HEAT_PRODUCTION has 57 outliers

ENGINE03_HEAT_PRODUCTION

numerical

Approximate Distinct Count 95
Approximate Unique (%) 26.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 18.6464
Minimum 0
Maximum 145.79
Zeros 267
Zeros (%) 74.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_HEAT_PRODUCTION is skewed right (γ1 = 1.9227)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1.1
95-th Percentile 100.1
Maximum 145.79
Range 145.79
IQR 1.1

Descriptive Statistics

Mean 18.6464
Standard Deviation 37.0886
Variance 1375.5636
Sum 6731.362
Skewness 1.9227
Kurtosis 2.5996
Coefficient of Variation 1.989
  • ENGINE03_HEAT_PRODUCTION is not normally distributed (p-value 4.643935000828453e-25)
  • ENGINE03_HEAT_PRODUCTION has 94 outliers

HOB_A_HEAT_PRODUCTION

categorical

Approximate Distinct Count 7
Approximate Unique (%) 1.9%
Missing 0
Missing (%) 0.0%
Memory Size 24.0 KB
  • The largest value (0.0) is over 355.0 times larger than the second largest value (19.42)

Length

Mean 3.0277
Standard Deviation 0.2219
Median 3
Minimum 3
Maximum 5

Sample

1st row 0.0
2nd row 0.0
3rd row 0.0
4th row 0.0
5th row 0.0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 732
  • The top 2 categories (0.0, 19.42) take over 50.0%
  • The largest value (00) is over 355.0 times larger than the second largest value (1942)

HOB_B_HEAT_PRODUCTION

categorical

Approximate Distinct Count 5
Approximate Unique (%) 1.4%
Missing 0
Missing (%) 0.0%
Memory Size 24.0 KB
  • The largest value (0.0) is over 357.0 times larger than the second largest value (10.37)

Length

Mean 3.0166
Standard Deviation 0.1658
Median 3
Minimum 3
Maximum 5

Sample

1st row 0.0
2nd row 0.0
3rd row 0.0
4th row 0.0
5th row 0.0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 728
  • The top 2 categories (0.0, 10.37) take over 50.0%
  • The largest value (00) is over 357.0 times larger than the second largest value (1037)

HEATPUMP_HEAT_PRODUCTION

numerical

Approximate Distinct Count 95
Approximate Unique (%) 26.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 2.95
Minimum 0
Maximum 15.6
Zeros 236
Zeros (%) 65.4%
Negatives 0
Negatives (%) 0.0%
  • HEATPUMP_HEAT_PRODUCTION is skewed right (γ1 = 1.3953)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 4.76
95-th Percentile 14.05
Maximum 15.6
Range 15.6
IQR 4.76

Descriptive Statistics

Mean 2.95
Standard Deviation 4.8644
Variance 23.6628
Sum 1064.954
Skewness 1.3953
Kurtosis 0.4695
Coefficient of Variation 1.649
  • HEATPUMP_HEAT_PRODUCTION is not normally distributed (p-value 4.907467168805532e-25)
  • HEATPUMP_HEAT_PRODUCTION has 34 outliers

FUELCELL_RECEIVED_HEAT_AMOUNT

numerical

Approximate Distinct Count 224
Approximate Unique (%) 95.3%
Missing 126
Missing (%) 34.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 3.7 KB
Mean 75.1219
Minimum 0
Maximum 105.9
Zeros 6
Zeros (%) 1.7%
Negatives 0
Negatives (%) 0.0%
  • FUELCELL_RECEIVED_HEAT_AMOUNT is skewed left (γ1 = -0.9327)

Quantile Statistics

Minimum 0
5-th Percentile 42.162
Q1 62.225
Median 73.33
Q3 94.53
95-th Percentile 102.458
Maximum 105.9
Range 105.9
IQR 32.305

Descriptive Statistics

Mean 75.1219
Standard Deviation 22.3924
Variance 501.4194
Sum 17653.65
Skewness -0.9327
Kurtosis 1.2558
Coefficient of Variation 0.2981
  • FUELCELL_RECEIVED_HEAT_AMOUNT is not normally distributed (p-value 0.00720952804449802)
  • FUELCELL_RECEIVED_HEAT_AMOUNT has 6 outliers

ENGINE01_FUEL_USAGE_METER

numerical

Approximate Distinct Count 37
Approximate Unique (%) 10.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 1.0058e+07
Minimum 9.7586e+06
Maximum 1.0325e+07
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_FUEL_USAGE_METER is skewed left (γ1 = -0.0889)

Quantile Statistics

Minimum 9.7586e+06
5-th Percentile 9.8073e+06
Q1 1.004e+07
Median 1.0069e+07
Q3 1.0079e+07
95-th Percentile 1.0325e+07
Maximum 1.0325e+07
Range 566384
IQR 39037

Descriptive Statistics

Mean 1.0058e+07
Standard Deviation 117724.8712
Variance 1.3859e+10
Sum 3.6309e+09
Skewness -0.08894
Kurtosis 1.4436
Coefficient of Variation 0.0117
  • ENGINE01_FUEL_USAGE_METER is not normally distributed (p-value 3.3829726277451086e-18)
  • ENGINE01_FUEL_USAGE_METER has 95 outliers

ENGINE02_FUEL_USAGE_METER

numerical

Approximate Distinct Count 114
Approximate Unique (%) 31.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 1.1231e+07
Minimum 9.3753e+06
Maximum 1.249e+07
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_FUEL_USAGE_METER is skewed left (γ1 = -1.3032)

Quantile Statistics

Minimum 9.3753e+06
5-th Percentile 1.0113e+07
Q1 1.1204e+07
Median 1.1365e+07
Q3 1.149e+07
95-th Percentile 1.1909e+07
Maximum 1.249e+07
Range 3.1142e+06
IQR 285809

Descriptive Statistics

Mean 1.1231e+07
Standard Deviation 527160.5941
Variance 2.779e+11
Sum 4.0543e+09
Skewness -1.3032
Kurtosis 2.2319
Coefficient of Variation 0.04694
  • ENGINE02_FUEL_USAGE_METER is not normally distributed (p-value 1.8954424403125852e-19)
  • ENGINE02_FUEL_USAGE_METER has 79 outliers

ENGINE03_FUEL_USAGE_METER

numerical

Approximate Distinct Count 96
Approximate Unique (%) 26.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 6.3965e+06
Minimum 5.3853e+06
Maximum 7.5371e+06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_FUEL_USAGE_METER is skewed left (γ1 = -0.1907)

Quantile Statistics

Minimum 5.3853e+06
5-th Percentile 5.4934e+06
Q1 6.291e+06
Median 6.3811e+06
Q3 6.597e+06
95-th Percentile 7.1427e+06
Maximum 7.5371e+06
Range 2.1518e+06
IQR 305977

Descriptive Statistics

Mean 6.3965e+06
Standard Deviation 407682.5812
Variance 1.6621e+11
Sum 2.3091e+09
Skewness -0.1907
Kurtosis 1.2618
Coefficient of Variation 0.06373
  • ENGINE03_FUEL_USAGE_METER is not normally distributed (p-value 1.732345878676927e-15)
  • ENGINE03_FUEL_USAGE_METER has 56 outliers

HOB_FUEL_USAGE

numerical

Approximate Distinct Count 41
Approximate Unique (%) 11.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 120030.6898
Minimum 111118
Maximum 134033
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • HOB_FUEL_USAGE is skewed right (γ1 = 0.1405)

Quantile Statistics

Minimum 111118
5-th Percentile 111290
Q1 116332
Median 120960
Q3 122019
95-th Percentile 129337
Maximum 134033
Range 22915
IQR 5687

Descriptive Statistics

Mean 120030.6898
Standard Deviation 5202.6749
Variance 2.7068e+07
Sum 4.3331e+07
Skewness 0.1405
Kurtosis 0.3265
Coefficient of Variation 0.04334
  • HOB_FUEL_USAGE is not normally distributed (p-value 4.944389741930886e-07)
  • HOB_FUEL_USAGE has 9 outliers

HEATPUMP_DAY_RUNTIME

numerical

Approximate Distinct Count 101
Approximate Unique (%) 28.5%
Missing 7
Missing (%) 1.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.5 KB
Mean 4.7029
Minimum 0
Maximum 24
Zeros 226
Zeros (%) 62.6%
Negatives 0
Negatives (%) 0.0%
  • HEATPUMP_DAY_RUNTIME is skewed right (γ1 = 1.3431)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 8.545
95-th Percentile 21.6765
Maximum 24
Range 24
IQR 8.545

Descriptive Statistics

Mean 4.7029
Standard Deviation 7.5529
Variance 57.0455
Sum 1664.82
Skewness 1.3431
Kurtosis 0.3231
Coefficient of Variation 1.606
  • HEATPUMP_DAY_RUNTIME is not normally distributed (p-value 5.073658268435166e-25)
  • HEATPUMP_DAY_RUNTIME has 19 outliers

HEATPUMP_ACCUM_RUNTIME

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.6%
Missing 180
Missing (%) 49.9%
Memory Size 12.0 KB

Length

Mean 3
Standard Deviation 0
Median 3
Minimum 3
Maximum 3

Sample

1st row 0.0
2nd row 0.0
3rd row 0.0
4th row 0.0
5th row 0.0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 362
  • HEATPUMP_ACCUM_RUNTIME has words of constant length

HOB_A_DAY_RUNTIME

numerical

Approximate Distinct Count 13
Approximate Unique (%) 3.7%
Missing 9
Missing (%) 2.5%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.5 KB
Mean 0.05585
Minimum 0
Maximum 2.5
Zeros 328
Zeros (%) 90.9%
Negatives 0
Negatives (%) 0.0%
  • HOB_A_DAY_RUNTIME is skewed right (γ1 = 5.7192)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0.5
Maximum 2.5
Range 2.5
IQR 0

Descriptive Statistics

Mean 0.05585
Standard Deviation 0.2435
Variance 0.05927
Sum 19.66
Skewness 5.7192
Kurtosis 39.6135
Coefficient of Variation 4.3589
  • HOB_A_DAY_RUNTIME is not normally distributed (p-value 4.5170803688382175e-25)
  • HOB_A_DAY_RUNTIME has 24 outliers

HOB_B_DAY_RUNTIME

numerical

Approximate Distinct Count 14
Approximate Unique (%) 4.0%
Missing 10
Missing (%) 2.8%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.5 KB
Mean 0.05536
Minimum 0
Maximum 4.83
Zeros 331
Zeros (%) 91.7%
Negatives 0
Negatives (%) 0.0%
  • HOB_B_DAY_RUNTIME is skewed right (γ1 = 10.6499)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0.485
Maximum 4.83
Range 4.83
IQR 0

Descriptive Statistics

Mean 0.05536
Standard Deviation 0.319
Variance 0.1018
Sum 19.43
Skewness 10.6499
Kurtosis 144.5839
Coefficient of Variation 5.7625
  • HOB_B_DAY_RUNTIME is not normally distributed (p-value 4.340469387994617e-25)
  • HOB_B_DAY_RUNTIME has 20 outliers

HOB_A_ACCUM_RUNTIME

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.6%
Missing 180
Missing (%) 49.9%
Memory Size 12.0 KB

Length

Mean 3
Standard Deviation 0
Median 3
Minimum 3
Maximum 3

Sample

1st row 0.0
2nd row 0.0
3rd row 0.0
4th row 0.0
5th row 0.0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 362
  • HOB_A_ACCUM_RUNTIME has words of constant length

HOB_B_ACCUM_RUNTIME

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.6%
Missing 180
Missing (%) 49.9%
Memory Size 12.0 KB

Length

Mean 3
Standard Deviation 0
Median 3
Minimum 3
Maximum 3

Sample

1st row 0.0
2nd row 0.0
3rd row 0.0
4th row 0.0
5th row 0.0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 362
  • HOB_B_ACCUM_RUNTIME has words of constant length

LNG_LOW_HEAT_AMOUNT

numerical

Approximate Distinct Count 34
Approximate Unique (%) 9.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 5.6 KB
Mean 9248.8197
Minimum 9191.869
Maximum 9269.792
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • LNG_LOW_HEAT_AMOUNT is skewed left (γ1 = -1.5391)

Quantile Statistics

Minimum 9191.869
5-th Percentile 9211.484
Q1 9243.192
Median 9251.792
Q3 9259.792
95-th Percentile 9267.792
Maximum 9269.792
Range 77.923
IQR 16.6

Descriptive Statistics

Mean 9248.8197
Standard Deviation 16.7227
Variance 279.6471
Sum 3.3388e+06
Skewness -1.5391
Kurtosis 2.3041
Coefficient of Variation 0.001808
  • LNG_LOW_HEAT_AMOUNT is not normally distributed (p-value 0.001362697397186633)
  • LNG_LOW_HEAT_AMOUNT has 39 outliers

ENGINE01_POWER_PRODUCTION

numerical

Approximate Distinct Count 35
Approximate Unique (%) 11.3%
Missing 52
Missing (%) 14.4%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.8 KB
Mean 4480.6868
Minimum 0
Maximum 201530
Zeros 275
Zeros (%) 76.2%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_POWER_PRODUCTION is skewed right (γ1 = 6.6932)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 1584.136
Maximum 201530
Range 201530
IQR 0

Descriptive Statistics

Mean 4480.6868
Standard Deviation 24765.0912
Variance 6.1331e+08
Sum 1.3845e+06
Skewness 6.6932
Kurtosis 46.4681
Coefficient of Variation 5.5271
  • ENGINE01_POWER_PRODUCTION is not normally distributed (p-value 4.291595440309906e-25)
  • ENGINE01_POWER_PRODUCTION has 34 outliers

ENGINE02_POWER_PRODUCTION

numerical

Approximate Distinct Count 102
Approximate Unique (%) 33.0%
Missing 52
Missing (%) 14.4%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.8 KB
Mean 28906.5334
Minimum 0
Maximum 201720
Zeros 200
Zeros (%) 55.4%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_POWER_PRODUCTION is skewed right (γ1 = 1.918)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 203.06
95-th Percentile 198416
Maximum 201720
Range 201720
IQR 203.06

Descriptive Statistics

Mean 28906.5334
Standard Deviation 59225.0172
Variance 3.5076e+09
Sum 8.9321e+06
Skewness 1.918
Kurtosis 2.2842
Coefficient of Variation 2.0488
  • ENGINE02_POWER_PRODUCTION is not normally distributed (p-value 5.838408343112009e-25)
  • ENGINE02_POWER_PRODUCTION has 74 outliers

ENGINE03_POWER_PRODUCTION

numerical

Approximate Distinct Count 88
Approximate Unique (%) 28.5%
Missing 52
Missing (%) 14.4%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.8 KB
Mean 15429.2764
Minimum 0
Maximum 203240
Zeros 220
Zeros (%) 60.9%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_POWER_PRODUCTION is skewed right (γ1 = 2.7831)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 43.8916
95-th Percentile 108866.4
Maximum 203240
Range 203240
IQR 43.8916

Descriptive Statistics

Mean 15429.2764
Standard Deviation 41960.1466
Variance 1.7607e+09
Sum 4.7676e+06
Skewness 2.7831
Kurtosis 6.9203
Coefficient of Variation 2.7195
  • ENGINE03_POWER_PRODUCTION is not normally distributed (p-value 4.487370296075998e-25)
  • ENGINE03_POWER_PRODUCTION has 64 outliers

ENGINE_TOTAL_POWER_PRODUCTION

numerical

Approximate Distinct Count 170
Approximate Unique (%) 55.0%
Missing 52
Missing (%) 14.4%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.8 KB
Mean 48816.4966
Minimum 0
Maximum 294170
Zeros 137
Zeros (%) 38.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE_TOTAL_POWER_PRODUCTION is skewed right (γ1 = 1.3965)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 89.48
Q3 99100
95-th Percentile 204938
Maximum 294170
Range 294170
IQR 99100

Descriptive Statistics

Mean 48816.4966
Standard Deviation 78142.634
Variance 6.1063e+09
Sum 1.5084e+07
Skewness 1.3965
Kurtosis 0.6963
Coefficient of Variation 1.6007
  • ENGINE_TOTAL_POWER_PRODUCTION is not normally distributed (p-value 8.818837602266325e-25)
  • ENGINE_TOTAL_POWER_PRODUCTION has 9 outliers

ENGINE01_FUEL_USAGE

numerical

Approximate Distinct Count 41
Approximate Unique (%) 13.3%
Missing 52
Missing (%) 14.4%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.8 KB
Mean 351855.1036
Minimum 0
Maximum 3.6877e+06
Zeros 242
Zeros (%) 67.0%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_FUEL_USAGE is skewed right (γ1 = 2.6617)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 3.4752e+06
Maximum 3.6877e+06
Range 3.6877e+06
IQR 0

Descriptive Statistics

Mean 351855.1036
Standard Deviation 1.0494e+06
Variance 1.1013e+12
Sum 1.0872e+08
Skewness 2.6617
Kurtosis 5.0885
Coefficient of Variation 2.9826
  • ENGINE01_FUEL_USAGE is not normally distributed (p-value 7.478955856290212e-25)
  • ENGINE01_FUEL_USAGE has 67 outliers

ENGINE02_FUEL_USAGE

numerical

Approximate Distinct Count 111
Approximate Unique (%) 35.9%
Missing 52
Missing (%) 14.4%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.8 KB
Mean 1.1613e+06
Minimum 0
Maximum 1.149e+07
Zeros 171
Zeros (%) 47.4%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_FUEL_USAGE is skewed right (γ1 = 2.6606)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 30312
95-th Percentile 1.149e+07
Maximum 1.149e+07
Range 1.149e+07
IQR 30312

Descriptive Statistics

Mean 1.1613e+06
Standard Deviation 3.451e+06
Variance 1.191e+13
Sum 3.5884e+08
Skewness 2.6606
Kurtosis 5.0792
Coefficient of Variation 2.9717
  • ENGINE02_FUEL_USAGE is not normally distributed (p-value 8.076424031276553e-25)
  • ENGINE02_FUEL_USAGE has 31 outliers

ENGINE03_FUEL_USAGE

numerical

Approximate Distinct Count 90
Approximate Unique (%) 29.1%
Missing 52
Missing (%) 14.4%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.8 KB
Mean 666518.932
Minimum 0
Maximum 6.597e+06
Zeros 189
Zeros (%) 52.3%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_FUEL_USAGE is skewed right (γ1 = 2.6609)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 20915
95-th Percentile 6.5936e+06
Maximum 6.597e+06
Range 6.597e+06
IQR 20915

Descriptive Statistics

Mean 666518.932
Standard Deviation 1.9782e+06
Variance 3.9133e+12
Sum 2.0595e+08
Skewness 2.6609
Kurtosis 5.0813
Coefficient of Variation 2.968
  • ENGINE03_FUEL_USAGE is not normally distributed (p-value 7.478955856290212e-25)
  • ENGINE03_FUEL_USAGE has 31 outliers

ENGINE_TOTAL_FUEL_USAGE

numerical

Approximate Distinct Count 173
Approximate Unique (%) 56.0%
Missing 52
Missing (%) 14.4%
Infinite 0
Infinite (%) 0.0%
Memory Size 4.8 KB
Mean 2.1797e+06
Minimum 0
Maximum 2.1562e+07
Zeros 110
Zeros (%) 30.5%
Negatives 0
Negatives (%) 0.0%
  • ENGINE_TOTAL_FUEL_USAGE is skewed right (γ1 = 2.6606)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 21887
Q3 44771
95-th Percentile 2.1559e+07
Maximum 2.1562e+07
Range 2.1562e+07
IQR 44771

Descriptive Statistics

Mean 2.1797e+06
Standard Deviation 6.4784e+06
Variance 4.197e+13
Sum 6.7351e+08
Skewness 2.6606
Kurtosis 5.0792
Coefficient of Variation 2.9722
  • ENGINE_TOTAL_FUEL_USAGE is not normally distributed (p-value 8.076424031276553e-25)
  • ENGINE_TOTAL_FUEL_USAGE has 31 outliers

ENGINE01_POWER_EFFICIENCE

numerical

Approximate Distinct Count 35
Approximate Unique (%) 23.8%
Missing 214
Missing (%) 59.3%
Infinite 0
Infinite (%) 0.0%
Memory Size 2.3 KB
Mean 9.4557
Minimum 0
Maximum 42.0191
Zeros 113
Zeros (%) 31.3%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_POWER_EFFICIENCE is skewed right (γ1 = 1.281)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 41.6459
Maximum 42.0191
Range 42.0191
IQR 0

Descriptive Statistics

Mean 9.4557
Standard Deviation 17.3146
Variance 299.7953
Sum 1389.9894
Skewness 1.281
Kurtosis -0.3505
Coefficient of Variation 1.8311
  • ENGINE01_POWER_EFFICIENCE is not normally distributed (p-value 4.1951337618922514e-24)
  • ENGINE01_POWER_EFFICIENCE has 34 outliers

ENGINE01_HEAT_EFFICIENCE

numerical

Approximate Distinct Count 30
Approximate Unique (%) 20.4%
Missing 214
Missing (%) 59.3%
Infinite 0
Infinite (%) 0.0%
Memory Size 2.3 KB
Mean 6.7318
Minimum 0
Maximum 39.4218
Zeros 118
Zeros (%) 32.7%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_HEAT_EFFICIENCE is skewed right (γ1 = 1.6302)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 37.6121
Maximum 39.4218
Range 39.4218
IQR 0

Descriptive Statistics

Mean 6.7318
Standard Deviation 13.9802
Variance 195.446
Sum 989.5725
Skewness 1.6302
Kurtosis 0.726
Coefficient of Variation 2.0767
  • ENGINE01_HEAT_EFFICIENCE is not normally distributed (p-value 5.867062361168565e-25)
  • ENGINE01_HEAT_EFFICIENCE has 29 outliers

ENGINE01_TOTAL_EFFICIENCE

numerical

Approximate Distinct Count 35
Approximate Unique (%) 23.8%
Missing 214
Missing (%) 59.3%
Infinite 0
Infinite (%) 0.0%
Memory Size 2.3 KB
Mean 11.7426
Minimum 0
Maximum 80.8019
Zeros 113
Zeros (%) 31.3%
Negatives 0
Negatives (%) 0.0%
  • ENGINE01_TOTAL_EFFICIENCE is skewed right (γ1 = 1.8988)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 76.245
Maximum 80.8019
Range 80.8019
IQR 0

Descriptive Statistics

Mean 11.7426
Standard Deviation 23.8017
Variance 566.5209
Sum 1726.1685
Skewness 1.8988
Kurtosis 2.2968
Coefficient of Variation 2.0269
  • ENGINE01_TOTAL_EFFICIENCE is not normally distributed (p-value 7.016986270619724e-25)
  • ENGINE01_TOTAL_EFFICIENCE has 34 outliers

ENGINE02_POWER_EFFICIENCE

numerical

Approximate Distinct Count 87
Approximate Unique (%) 42.9%
Missing 158
Missing (%) 43.8%
Infinite 0
Infinite (%) 0.0%
Memory Size 3.2 KB
Mean 1103.7619
Minimum 0
Maximum 209650.7512
Zeros 117
Zeros (%) 32.4%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_POWER_EFFICIENCE is skewed right (γ1 = 14.1193)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 41.6705
95-th Percentile 42.0258
Maximum 209650.7512
Range 209650.7512
IQR 41.6705

Descriptive Statistics

Mean 1103.7619
Standard Deviation 14717.6166
Variance 2.1661e+08
Sum 224063.6695
Skewness 14.1193
Kurtosis 197.5669
Coefficient of Variation 13.3341
  • ENGINE02_POWER_EFFICIENCE is not normally distributed (p-value 4.255227536283322e-25)
  • ENGINE02_POWER_EFFICIENCE has 6 outliers

ENGINE02_HEAT_EFFICIENCE

numerical

Approximate Distinct Count 84
Approximate Unique (%) 41.4%
Missing 158
Missing (%) 43.8%
Infinite 0
Infinite (%) 0.0%
Memory Size 3.2 KB
Mean 971.7095
Minimum 0
Maximum 184645.0262
Zeros 120
Zeros (%) 33.2%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_HEAT_EFFICIENCE is skewed right (γ1 = 14.1208)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 36.8899
95-th Percentile 38.4425
Maximum 184645.0262
Range 184645.0262
IQR 36.8899

Descriptive Statistics

Mean 971.7095
Standard Deviation 12961.7522
Variance 1.6801e+08
Sum 197257.0353
Skewness 14.1208
Kurtosis 197.5963
Coefficient of Variation 13.3391
  • ENGINE02_HEAT_EFFICIENCE is not normally distributed (p-value 4.255227536283322e-25)
  • ENGINE02_HEAT_EFFICIENCE has 6 outliers

ENGINE02_TOTAL_EFFICIENCE

numerical

Approximate Distinct Count 87
Approximate Unique (%) 42.9%
Missing 158
Missing (%) 43.8%
Infinite 0
Infinite (%) 0.0%
Memory Size 3.2 KB
Mean 2061.0617
Minimum 0
Maximum 394295.7775
Zeros 117
Zeros (%) 32.4%
Negatives 0
Negatives (%) 0.0%
  • ENGINE02_TOTAL_EFFICIENCE is skewed right (γ1 = 14.12)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 39.2643
95-th Percentile 40.2897
Maximum 394295.7775
Range 394295.7775
IQR 39.2643

Descriptive Statistics

Mean 2061.0617
Standard Deviation 27680.4026
Variance 7.662e+08
Sum 418395.5346
Skewness 14.12
Kurtosis 197.5802
Coefficient of Variation 13.4302
  • ENGINE02_TOTAL_EFFICIENCE is not normally distributed (p-value 4.255227536283322e-25)
  • ENGINE02_TOTAL_EFFICIENCE has 6 outliers

ENGINE03_POWER_EFFICIENCE

numerical

Approximate Distinct Count 53
Approximate Unique (%) 30.3%
Missing 186
Missing (%) 51.5%
Infinite 0
Infinite (%) 0.0%
Memory Size 2.7 KB
Mean 882.3638
Minimum 0
Maximum 138555.5721
Zeros 123
Zeros (%) 34.1%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_POWER_EFFICIENCE is skewed right (γ1 = 12.9835)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 43.3012
95-th Percentile 43.9267
Maximum 138555.5721
Range 138555.5721
IQR 43.3012

Descriptive Statistics

Mean 882.3638
Standard Deviation 10503.7125
Variance 1.1033e+08
Sum 154413.6699
Skewness 12.9835
Kurtosis 167.6009
Coefficient of Variation 11.9041
  • ENGINE03_POWER_EFFICIENCE is not normally distributed (p-value 4.241797053818128e-25)
  • ENGINE03_POWER_EFFICIENCE has 4 outliers

ENGINE03_HEAT_EFFICIENCE

numerical

Approximate Distinct Count 50
Approximate Unique (%) 28.6%
Missing 186
Missing (%) 51.5%
Infinite 0
Infinite (%) 0.0%
Memory Size 2.7 KB
Mean 716.1808
Minimum 0
Maximum 112794.6012
Zeros 126
Zeros (%) 34.9%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_HEAT_EFFICIENCE is skewed right (γ1 = 12.9918)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 31.5678
95-th Percentile 36.7254
Maximum 112794.6012
Range 112794.6012
IQR 31.5678

Descriptive Statistics

Mean 716.1808
Standard Deviation 8549.0203
Variance 7.3086e+07
Sum 125331.6395
Skewness 12.9918
Kurtosis 167.7557
Coefficient of Variation 11.937
  • ENGINE03_HEAT_EFFICIENCE is not normally distributed (p-value 4.241797053818128e-25)
  • ENGINE03_HEAT_EFFICIENCE has 4 outliers

ENGINE03_TOTAL_EFFICIENCE

numerical

Approximate Distinct Count 53
Approximate Unique (%) 30.3%
Missing 186
Missing (%) 51.5%
Infinite 0
Infinite (%) 0.0%
Memory Size 2.7 KB
Mean 1588.4523
Minimum 0
Maximum 251350.1732
Zeros 123
Zeros (%) 34.1%
Negatives 0
Negatives (%) 0.0%
  • ENGINE03_TOTAL_EFFICIENCE is skewed right (γ1 = 12.9872)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 38.454
95-th Percentile 40.3225
Maximum 251350.1732
Range 251350.1732
IQR 38.454

Descriptive Statistics

Mean 1588.4523
Standard Deviation 19053.5318
Variance 3.6304e+08
Sum 277979.1493
Skewness 12.9872
Kurtosis 167.6693
Coefficient of Variation 11.995
  • ENGINE03_TOTAL_EFFICIENCE is not normally distributed (p-value 4.241797053818128e-25)
  • ENGINE03_TOTAL_EFFICIENCE has 4 outliers

REG_DT

categorical

Approximate Distinct Count 181
Approximate Unique (%) 98.4%
Missing 177
Missing (%) 49.0%
Memory Size 15.8 KB

Length

Mean 23
Standard Deviation 0
Median 23
Minimum 23
Maximum 23

Sample

1st row 2020-06-29 08:53:1...
2nd row 2020-06-29 08:53:1...
3rd row 2020-06-29 08:53:1...
4th row 2020-06-30 12:08:2...
5th row 2020-07-01 09:13:5...

Letter

Count 0
Lowercase Letter 0
Space Separator 184
Uppercase Letter 0
Dash Punctuation 368
Decimal Number 3128
  • The largest value (20200921) is over 5.0 times larger than the second largest value (20200714)
  • REG_DT has words of constant length

REG_USER

categorical

Approximate Distinct Count 2
Approximate Unique (%) 1.1%
Missing 180
Missing (%) 49.9%
Memory Size 13.0 KB

Length

Mean 8.8287
Standard Deviation 3.4942
Median 12
Minimum 5
Maximum 12

Sample

1st row admin
2nd row admin
3rd row admin
4th row admin
5th row admin

Letter

Count 1598
Lowercase Letter 1400
Space Separator 0
Uppercase Letter 198
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (DataUploader, admin) take over 50.0%

Interactions

Correlations

Missing Values